Tabular Model - Salary Review Analysis

Contents

• Usage/Purpose
• Fact Tables
• Dimension Tables
• Configurations
• Limitations
• Relationships

Usage/Purpose

Fact Tables

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
COMP AND BEN MEASURES	FACT_SAL_REVIEW_BUDGET_INFO_TM	FACT_SAL_REVIEW_BUDGET_INFO_BI	FACT_SAL_REVIEW_BUDGET_INFO	Data Mart

 Corresponding Information Sources are described below. Detailed infomation about Information Sources can be found in About Information Sources

Dimension Tables

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
BUDGET INFO RLS ID	BUDGET_INFO_RLS_ID	FACT_SAL_REVIEW_BUDGET_INFO_BI, SAL_REVIEW_BUDGET_INFO_RLS	BUDGET_INFO_RLS_ID	On Line
COMPANY	DIM_COMPANY_TM	DIM_COMPANY_BI	DIM_COMPANY	On Line
COMPENSATION TYPE	DIM_COMPENSATION_TYPE_TM	DIM_COMPENSATION_TYPE_BI	DIM_COMPENSATION_TYPE	On Line
EMPLOYEE	DIM_EMPLOYEE_PERSON_TM	DIM_EMPLOYEE_PERSON_BI	DIM_EMPLOYEE_PERSON	On Line
EMPLOYEE CATEGORY	DIM_EMPLOYEE_CATEGORY_TM	DIM_EMPLOYEE_CATEGORY_BI	DIM_EMPLOYEE_CATEGORY	On Line
JOB DETAILS	DIM_JOB_DETAILS_TM	DIM_JOB_DETAILS_BI	DIM_JOB_DETAILS	On Line
ORGANIZATION CODE	DIM_ORGANIZATION_CODE_TM	DIM_ORGANIZATION_CODE_BI	DIM_ORGANIZATION_CODE	On Line
POSITION	DIM_POSITION_TM	DIM_POSITION_BI	DIM_POSITION	On Line
SAL REVIEW BUDGET INFO	FACT_SAL_REVIEW_BUDGET_INFO_TM	FACT_SAL_REVIEW_BUDGET_INFO_BI	FACT_SAL_REVIEW_BUDGET_INFO	Data Mart
SAL REVIEW BUDGET INFO RLS	SAL_REVIEW_BUDGET_INFO_RLS	SAL_REVIEW_BUDGET_INFO_RLS	SAL_REVIEW_BUDGET_INFO_RLS	On Line
SAL REVIEW COMP DETAIL	FACT_SAL_REVIEW_COMP_DETAIL_TM	FACT_SAL_REVIEW_COMP_DETAIL_BI	FACT_SAL_REVIEW_COMP_DETAIL	Data Mart
SAL REVIEW COMP DETAIL EMP RLS	DIM_EMPLOYEE_PERSON_TM	DIM_EMPLOYEE_PERSON_BI	DIM_EMPLOYEE_PERSON	On Line
SAL REVIEW COMP DETAIL RLS	SAL_REVIEW_COMP_DETAIL_RLS	SAL_REVIEW_COMP_DETAIL_RLS	SAL_REVIEW_COMP_DETAIL_RLS	On Line
SALARY REVIEW INFO	FACT_SALARY_REVIEW_INFO_TM	FACT_SALARY_REVIEW_INFO_BI	FACT_SALARY_REVIEW_INFO	Data Mart
SALARY REVIEW INFO EMP RLS	DIM_EMPLOYEE_PERSON_TM	DIM_EMPLOYEE_PERSON_BI	DIM_EMPLOYEE_PERSON	On Line
SALARY REVIEW INFO RLS	SALARY_REVIEW_INFO_RLS	SALARY_REVIEW_INFO_RLS	SALARY_REVIEW_INFO_RLS	On Line
SALARY REVIEW PERIOD	DIM_SALARY_REVIEW_PERIOD_TM	DIM_SALARY_REVIEW_PERIOD_BI	DIM_SALARY_REVIEW_PERIOD_TM	On Line
WORK LOCATION	DIM_WORK_LOCATION_TM	DIM_WORK_LOCATION_BI	DIM_WORK_LOCATION	On Line

Configurations

Limitations

Relationships

The following table lists the relationships between tables and columns in the model.

Relationship: Table (column) - Table (column)

SALARY REVIEW INFO (DIM_COMPANY_ID) - COMPANY (ID)

SALARY REVIEW INFO (DIM_EMPLOYEE_CATEGORY_ID) - EMPLOYEE CATEGORY (ID)

SALARY REVIEW INFO (DIM_EMP_NO) - EMPLOYEE (ID)

SALARY REVIEW INFO (DIM_EMP_NO_RLS) - SALARY REVIEW INFO EMP RLS (ID)

SALARY REVIEW INFO (DIM_JOB_ID) - JOB DETAILS (ID)

SALARY REVIEW INFO (DIM_ORG_CODE) - ORGANIZATION CODE (ID)

SALARY REVIEW INFO (DIM_POS_CODE) - POSITION (ID)

SALARY REVIEW INFO (DIM_REVIEW_PERIOD_ID) - SALARY REVIEW PERIOD (ID)

SALARY REVIEW INFO (DIM_WORK_LOCATION) - WORK LOCATION (ID)

SALARY REVIEW INFO RLS (SALARY_REVIEW_INFO_EMP_NO) - SALARY REVIEW INFO EMP RLS (ID)

SAL REVIEW BUDGET INFO (DIM_COMPANY_ID) - COMPANY (ID)

SAL REVIEW BUDGET INFO (DIM_REVIEW_PERIOD_ID) - SALARY REVIEW PERIOD (ID)

SAL REVIEW BUDGET INFO (DIM_SALARY_SETTING_MANAGER_ID) - EMPLOYEE (ID)

SAL REVIEW BUDGET INFO (DIM_SALARY_SETTING_ORG_CODE) - ORGANIZATION CODE (ID)

SAL REVIEW BUDGET INFO (ID) - BUDGET INFO RLS ID (ID)

SAL REVIEW BUDGET INFO RLS (SAL_REVIEW_BUDGET_INFO_ID) - BUDGET INFO RLS ID (ID)

SAL REVIEW COMP DETAIL (DIM_COMPANY_ID) - COMPANY (ID)

SAL REVIEW COMP DETAIL (DIM_COMPENSATION_TYPE_ID) - COMPENSATION TYPE (ID)

SAL REVIEW COMP DETAIL (DIM_EMPLOYEE_CATEGORY_ID) - EMPLOYEE CATEGORY (ID)

SAL REVIEW COMP DETAIL (DIM_EMP_NO) - EMPLOYEE (ID)

SAL REVIEW COMP DETAIL (DIM_EMP_NO_RLS) - SAL REVIEW COMP DETAIL EMP RLS (ID)

SAL REVIEW COMP DETAIL (DIM_JOB_ID) - JOB DETAILS (ID)

SAL REVIEW COMP DETAIL (DIM_ORG_CODE) - ORGANIZATION CODE (ID)

SAL REVIEW COMP DETAIL (DIM_POS_CODE) - POSITION (ID)

SAL REVIEW COMP DETAIL (DIM_REVIEW_PERIOD_ID) - SALARY REVIEW PERIOD (ID)

SAL REVIEW COMP DETAIL (DIM_WORK_LOCATION) - WORK LOCATION (ID)

SAL REVIEW COMP DETAIL RLS (SAL_REVIEW_COMP_DETAIL_EMP_NO) - SAL REVIEW COMP DETAIL EMP RLS (ID)